package br.com.listadecompras.utils;

import br.com.listadecompras.DAO.GroupDAO;
import br.com.listadecompras.DAO.ItemDAO;

public class Constantes {

	public static class DataBaseConstantes {
		
		public static final String DATABASE_NAME = "ListaCompras";
		
		public static class AuxTables {
		
			public static final String CREATE_TABLE_GROUP_ITENS = 
						"CREATE TABLE IF NOT EXISTS " + AuxTables.TABLE_GROUP_ITENS_NAME + "(" +
						" ID       INTEGER PRIMARY KEY AUTOINCREMENT,"+
						" ID_GROUP INTEGER,"+
						" ID_ITEM  INTEGER,"+
						" FOREIGN KEY(ID_GROUP) REFERENCES " + GroupDAO.TABLE_NAME + "(ID)"+
						" FOREIGN KEY(ID_ITEM) REFERENCES " + ItemDAO.TABLE_NAME + "(ID) );";
			
			public static final String TABLE_GROUP_ITENS_NAME = "TB_GROUP_ITENS";
		}
	}
}
